UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZS2wqwEHKORXb+B/zTzi4m6v9qLW8wQHYFOHUwXWLcU='
WHERE
key_id = '938b7dd29ca7ccc04dfafb727d29b1f340d2bcf041dcd0323f3f308b3cdaa724'
AND (
token = 'ZS2wqwEHKORXb+B/zTzi4m6v9qLW8wQHYFOHUwXWLcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)