SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '499f34e2282106d9c22987c9954b58620af90780b6c3071c605a9713f6dec24b' 
  AND token = '2XmPYufAOewLZs9uXgf2MNMuudV2d5RjDV4oH60dtbU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}