UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9p9BcvKMJRpGR2OIXwIwV6HrDxcoSm/ugLO+nnNNnI='
WHERE
key_id = 'ecea94ad8dc8affc4717b026a4593caa2fdbc2c6f1b3c4895f351529fcae9760'
AND (
token = 'N9p9BcvKMJRpGR2OIXwIwV6HrDxcoSm/ugLO+nnNNnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)