UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FjmaWOYi+u+AcUeISIeVXE9yCtztXJGPMEVIC/u8ZM4='
WHERE
key_id = '17fc422b387c9aee9825cffc17449b755aff12cf457b614e404e038cf4372cfc'
AND (
token = 'FjmaWOYi+u+AcUeISIeVXE9yCtztXJGPMEVIC/u8ZM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)