UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c07kI5MU3FyHPuJmp10ntS1kNp4Fv1JuQxD7q7dhVfg='
WHERE
key_id = 'bc6aa3ee48e3e8c4710190ba859c9836757a2c1e87ba05581438aaebc23024d2'
AND (
token = 'c07kI5MU3FyHPuJmp10ntS1kNp4Fv1JuQxD7q7dhVfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)