UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TiIu7CfRR9V7gus89dZ3OBMQrF42WhH5ZD7kn6Yvtbs=' 
WHERE 
  key_id = '264e217f39b72983c3963ce57edbfb4641cb85b6bcafd8a68477b1eb7c8aac15' 
  AND (
    token = 'TiIu7CfRR9V7gus89dZ3OBMQrF42WhH5ZD7kn6Yvtbs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00086