UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06h7eGBgSbytaJqQIdcTYFPVUyKRpBO1xB4PPSz1cgM='
WHERE
key_id = '20e83e047a8ac1a07dee7a7e4b7296236eda5f359c0d9e6d060c8715334dc5ae'
AND (
token = '06h7eGBgSbytaJqQIdcTYFPVUyKRpBO1xB4PPSz1cgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)