UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+hp6VVsx58vxnp4Sj23ljkcKKlGCITMLHwTzcNAoB3M='
WHERE
key_id = '244b52731e4bd3e019fcf2a107c743c600772e7be36492c490ae3528be9db2ce'
AND (
token = '+hp6VVsx58vxnp4Sj23ljkcKKlGCITMLHwTzcNAoB3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)