UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKzlpC3f38GNzvc/gM2oar8CE/GhIFGCQaDtSOcE0Tc='
WHERE
key_id = 'f9e583d152c66f54dea37aee7a60ebf848588f6a13af0e0d881aa2058503ec3e'
AND (
token = 'RKzlpC3f38GNzvc/gM2oar8CE/GhIFGCQaDtSOcE0Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)