UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BrctV7U3M0Ziq85eHMGRddqwSnlZir4zcTM0q7wIzs='
WHERE
key_id = '1cacebca315ea49e2bbdf6ba96c237f518aa27fac9345beee59adeefac47b795'
AND (
token = '0BrctV7U3M0Ziq85eHMGRddqwSnlZir4zcTM0q7wIzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)