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