UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OlS2769dH7/oLmrYUAYRXJve/9s3My5SHxwNwEQl/xI=' 
WHERE 
  key_id = 'a03fc75224b199b66e7041b1f86da4359865036d75120cea1f9d44027336630c' 
  AND (
    token = 'OlS2769dH7/oLmrYUAYRXJve/9s3My5SHxwNwEQl/xI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044