UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'drhVTHtICHiGJzMviZ0kNf9abs0+3OI/vUQ22dYdYGw='
WHERE
key_id = 'b173a7345ef4d26192f5e414b59e438dc002c3df4e5d0e80c693244f4725465b'
AND (
token = 'drhVTHtICHiGJzMviZ0kNf9abs0+3OI/vUQ22dYdYGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)