UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47zbM40oPFx6nWtQmsR47W+QprlM4R6xYNK8OZK0pKg='
WHERE
key_id = '0e3bda897bb7f0398d1d80f7ec523918c9cfce55ec08707ee014c7a87b26181c'
AND (
token = '47zbM40oPFx6nWtQmsR47W+QprlM4R6xYNK8OZK0pKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)