UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrL7/3w86ukbuUsfpUerrfhO740rLRRVt95fNcEHcXM='
WHERE
key_id = '3428da6fba3ede5f4a8b14432b45f5f90be64255f24a4d8b795d53e0d2fcce72'
AND (
token = 'zrL7/3w86ukbuUsfpUerrfhO740rLRRVt95fNcEHcXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)