UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LWTo/fZM1Wf07NU6ImiTf4LJ60LyKCIEchCj13iIRPw='
WHERE
key_id = 'cf81f2e65fd311de05eb7f282ebbb5f486308ff5894c4c88d92914375089853c'
AND (
token = 'LWTo/fZM1Wf07NU6ImiTf4LJ60LyKCIEchCj13iIRPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)