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