UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+j0eg6KU47gGzAOs3lCMZo42KAqUMyHXUMDU1eSYXiU='
WHERE
key_id = '505c1c4ef3c2009cdec8ea75a08a20e5ca319adc0c5d35701705b8bfaa71fb3c'
AND (
token = '+j0eg6KU47gGzAOs3lCMZo42KAqUMyHXUMDU1eSYXiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)