UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jh/uMdcZWu9ROAB+1miMRVLJVKR3bgsICGGniMT4AOE='
WHERE
key_id = 'dcf89070bbb41f9532cb0b4d8bfd1bc0a0edd727bfc36e0a35f62a909f61867e'
AND (
token = 'Jh/uMdcZWu9ROAB+1miMRVLJVKR3bgsICGGniMT4AOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)