UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1QN2V8jELvzyLrJvHzwR2JlzY5wlFp80ogGBuwDaScs='
WHERE
key_id = '97f718748e1480e6a4a40a474ede69d849e922d8012c93206320d09dc97b2911'
AND (
token = '1QN2V8jELvzyLrJvHzwR2JlzY5wlFp80ogGBuwDaScs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)