UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdh3+lglX/GVWnBQ7rFONPyaM4vUas18RH0K12ZjCGs='
WHERE
key_id = 'c769a44eef55ebcfa8192ea7a9642f47054182dff672ae48246adb09b467c633'
AND (
token = 'zdh3+lglX/GVWnBQ7rFONPyaM4vUas18RH0K12ZjCGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)