UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DSwEooZvEynHEJhvBMIqV0Q0bsAt6Fjl6KlV674s1WE='
WHERE
key_id = '9ae4e88ae894d9b7887aa2c53c9f22c0dc299fac8a33b4cd8390aa7accbf6038'
AND (
token = 'DSwEooZvEynHEJhvBMIqV0Q0bsAt6Fjl6KlV674s1WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)