UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MiZfHMZX0IOqQmnuLs10Xu+3fDPiC9h99MTc9KHVry0='
WHERE
key_id = '3d676a4096787776b96d20c28ab262e5b09736f0389f168f8852862cdfae78ed'
AND (
token = 'MiZfHMZX0IOqQmnuLs10Xu+3fDPiC9h99MTc9KHVry0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)