UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRdSjI8OOd5d0bo4GDW/r4POt4P8O9dCiZiiuOBPApw='
WHERE
key_id = '78f4663a75ca32ab89359a36644012c998c45b31bd92eaa3a38506894d2a9d7b'
AND (
token = 'iRdSjI8OOd5d0bo4GDW/r4POt4P8O9dCiZiiuOBPApw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)