UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FJIRC8Jk1OLdQioUEtPHBJjsSXrhDp3PIZS1etujHKw='
WHERE
key_id = 'a914d48b7ce04b4323b6c8ba0358b787ad3ef56a02983ab4d8dee0494bed8f26'
AND (
token = 'FJIRC8Jk1OLdQioUEtPHBJjsSXrhDp3PIZS1etujHKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)