UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Q3ZtED2VqGdWxHWbMilj+vok/lZKDEzm03s6P9C/368=' 
WHERE 
  key_id = '70a9ac349e4ea635157e3d7bcb5d13deb9f2e33600c56dfa498fa3f9a4b6dbbf' 
  AND (
    token = 'Q3ZtED2VqGdWxHWbMilj+vok/lZKDEzm03s6P9C/368=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021