UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '82Wg7Dsw5rSKEF1UKXcNli/ekEPrX94kfSE/8CGZzVM='
WHERE
key_id = 'a1173ee85e356ea44fa195382fb5953ccb1982bd31f386ef6b5fc25de4f4e68c'
AND (
token = '82Wg7Dsw5rSKEF1UKXcNli/ekEPrX94kfSE/8CGZzVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)