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