UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2d7Yvljm7fhFpVtUnvGBH2JR5xNPmjFWwQzGCzu7J8w='
WHERE
key_id = '5f128d1f89af306007b7529e574cf3d72f597313aceba04aa1bcc813ffac7ae2'
AND (
token = '2d7Yvljm7fhFpVtUnvGBH2JR5xNPmjFWwQzGCzu7J8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)