UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrTJfdouHwfaeZG6djGHzYDC/FTSUJMAUyTrFSsFfgY='
WHERE
key_id = '8d9672fbd25375f0bf8c9ff6e82a16a9a8fcd1dc39c4f58765e5c2043323aa65'
AND (
token = 'ZrTJfdouHwfaeZG6djGHzYDC/FTSUJMAUyTrFSsFfgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)