UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bk+XfPfD11vtwpPwgpoe1dESzUYMsskBG8AFV2hN6/w='
WHERE
key_id = 'a3344eded2f622a5e591abd36b67d4af6c46568adb1974bdb52df3562b433faa'
AND (
token = 'bk+XfPfD11vtwpPwgpoe1dESzUYMsskBG8AFV2hN6/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)