UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4APPAQgPOfzNKVp1gmZZhOfDcHFYKXHfaqb9n88Dbc='
WHERE
key_id = '49fd12313a328603ac1b40e9b0e35eaf89aa281d80de6e487ee33e42476f5a24'
AND (
token = 'd4APPAQgPOfzNKVp1gmZZhOfDcHFYKXHfaqb9n88Dbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)