UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PN3ykp5wsRiVMCc2jJJ9Le3vVEV6DEMU4PjcXaqvLk8='
WHERE
key_id = '9efc9cfe706b27e460ffe6490a26a74da92ce82bf4274097fd9260170ca9fc4e'
AND (
token = 'PN3ykp5wsRiVMCc2jJJ9Le3vVEV6DEMU4PjcXaqvLk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)