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