UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30iAJwqoxvHaDbo87HSopIMNYt7NXa7b+sprJ5SKEcM='
WHERE
key_id = '5811128a5fb1029b692ba135ee71fa89b79d3e92b21caf65a6915cf61b15751d'
AND (
token = '30iAJwqoxvHaDbo87HSopIMNYt7NXa7b+sprJ5SKEcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)